<%@page import="net.sf.jasperreports.engine.base.JRBaseStaticText"%>
<%@page import="java.awt.Color"%>
<%@page import="net.sf.jasperreports.engine.JRElement"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"%>
<%@ page import="java.util.Date" %>
<%@include file="/include/common/reportbackhead.jsp"%>
<%!
private class PageAction extends BaseAction{
	//加載頁面默認數據
	protected boolean onLoadDefault() throws Exception {
		form.SetParamValue("printdate",new Date());
		onSearch();
		return true;
	}	
	
	protected void onSearchRetrieveResult() throws Exception{
		ResultSet rs = null;
		rs = utils.executeQuery("info5","select distinct billNo,orderno,hrNum,dh_no,sqty from("+
		" select billNo,orderno,hrNum,dh_no,gx_no,SUM(sqty) as sqty from mf..jj003 where convert(nvarchar(10),crtDay,111)='2012/02/25' group by billNo,orderno,hrNum,dh_no,gx_no) k"+
		" order by hrNum,billNo,dh_no"+
		" ");
		ret.SetSearchResult(rs);
	}
	
	public void initJasperReport(JasperReport report) throws Exception{
		
	}
}
%>
<%@include file="/include/common/reportbackend.jsp"%>